SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002290s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.001878s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002610s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000587s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002757s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000327s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002364s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000364s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002498s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000715s ]
UPDATE `stock_search` SET `count` = 1958 , `updatetime` = '2026-06-06 21:05:28' WHERE `partno` = '210' [ RunTime:0.002313s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002921s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.005105s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.001027s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002664s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.102187s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '210%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 3160,20 [ RunTime:0.058018s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('32878645','32878644','32878643','32878642','32878641','32878640','32878639','32878638','32878637','32878636','32878635','32878634','32878633','32873041','32873040','32872668','32872585','32872368','32856387','32856386') ORDER BY FIELD(s.id, 32878645,32878644,32878643,32878642,32878641,32878640,32878639,32878638,32878637,32878636,32878635,32878634,32878633,32873041,32873040,32872668,32872585,32872368,32856387,32856386) [ RunTime:0.016500s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878645 LIMIT 4 [ RunTime:0.026118s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.020059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878645 ORDER BY `minOrder` ASC [ RunTime:0.021539s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878645 ORDER BY `unit` DESC [ RunTime:0.019439s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878645 LIMIT 2 [ RunTime:0.012323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878645 ORDER BY `minOrder` ASC [ RunTime:0.006788s ]
select * from pdf where partno='210-2MST' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.024712s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2MST' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878644 LIMIT 4 [ RunTime:0.001267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878644 ORDER BY `minOrder` ASC [ RunTime:0.026140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878644 ORDER BY `unit` DESC [ RunTime:0.004365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878644 LIMIT 2 [ RunTime:0.015887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878644 ORDER BY `minOrder` ASC [ RunTime:0.019168s ]
select * from pdf where partno='210-2LPST' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.029416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2LPST' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878643 LIMIT 4 [ RunTime:0.027079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878643 ORDER BY `minOrder` ASC [ RunTime:0.047827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878643 ORDER BY `unit` DESC [ RunTime:0.018521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878643 LIMIT 2 [ RunTime:0.050121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878643 ORDER BY `minOrder` ASC [ RunTime:0.042133s ]
select * from pdf where partno='210-2ESFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.012211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2ESFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.019210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878642 LIMIT 4 [ RunTime:0.019653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878642 ORDER BY `minOrder` ASC [ RunTime:0.055312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878642 ORDER BY `unit` DESC [ RunTime:0.057175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878642 LIMIT 2 [ RunTime:0.008968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878642 ORDER BY `minOrder` ASC [ RunTime:0.009113s ]
select * from pdf where partno='210-2MSFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.021415s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2MSFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878641 LIMIT 4 [ RunTime:0.003246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878641 ORDER BY `minOrder` ASC [ RunTime:0.004598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878641 ORDER BY `unit` DESC [ RunTime:0.008603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878641 LIMIT 2 [ RunTime:0.020300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878641 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
select * from pdf where partno='210-2LPSFD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.012153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2LPSFD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.022566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878640 LIMIT 4 [ RunTime:0.008998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878640 ORDER BY `minOrder` ASC [ RunTime:0.028793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878640 ORDER BY `unit` DESC [ RunTime:0.021454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878640 LIMIT 2 [ RunTime:0.039161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878640 ORDER BY `minOrder` ASC [ RunTime:0.000567s ]
select * from pdf where partno='210-2ESD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2ESD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.025911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878639 LIMIT 4 [ RunTime:0.026757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878639 ORDER BY `minOrder` ASC [ RunTime:0.023887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878639 ORDER BY `unit` DESC [ RunTime:0.015038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878639 LIMIT 2 [ RunTime:0.009012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878639 ORDER BY `minOrder` ASC [ RunTime:0.011953s ]
select * from pdf where partno='210-2MSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2MSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.033628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878638 LIMIT 4 [ RunTime:0.013564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878638 ORDER BY `minOrder` ASC [ RunTime:0.008327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878638 ORDER BY `unit` DESC [ RunTime:0.026407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878638 LIMIT 2 [ RunTime:0.033583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878638 ORDER BY `minOrder` ASC [ RunTime:0.011208s ]
select * from pdf where partno='210-2LPSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2LPSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.050722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878637 LIMIT 4 [ RunTime:0.027894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878637 ORDER BY `minOrder` ASC [ RunTime:0.007871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878637 ORDER BY `unit` DESC [ RunTime:0.014533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878637 LIMIT 2 [ RunTime:0.022921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878637 ORDER BY `minOrder` ASC [ RunTime:0.016455s ]
select * from pdf where partno='210-2ESF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.039588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2ESF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.049924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878636 LIMIT 4 [ RunTime:0.025973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878636 ORDER BY `minOrder` ASC [ RunTime:0.037005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878636 ORDER BY `unit` DESC [ RunTime:0.044022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878636 LIMIT 2 [ RunTime:0.004176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878636 ORDER BY `minOrder` ASC [ RunTime:0.040037s ]
select * from pdf where partno='210-2MSF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.018644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2MSF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.036422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878635 LIMIT 4 [ RunTime:0.043716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878635 ORDER BY `minOrder` ASC [ RunTime:0.024418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878635 ORDER BY `unit` DESC [ RunTime:0.017532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878635 LIMIT 2 [ RunTime:0.007826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878635 ORDER BY `minOrder` ASC [ RunTime:0.031137s ]
select * from pdf where partno='210-2LPSF' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.025043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2LPSF' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.031448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878634 LIMIT 4 [ RunTime:0.019276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878634 ORDER BY `minOrder` ASC [ RunTime:0.023469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878634 ORDER BY `unit` DESC [ RunTime:0.024795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878634 LIMIT 2 [ RunTime:0.013458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878634 ORDER BY `minOrder` ASC [ RunTime:0.012473s ]
select * from pdf where partno='210-2ES' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2ES' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.031988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32878633 LIMIT 4 [ RunTime:0.022236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878633 ORDER BY `minOrder` ASC [ RunTime:0.034099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32878633 ORDER BY `unit` DESC [ RunTime:0.050439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32878633 LIMIT 2 [ RunTime:0.027067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32878633 ORDER BY `minOrder` ASC [ RunTime:0.019543s ]
select * from pdf where partno='210-2LPS' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.023506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-2LPS' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.036068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32873041 LIMIT 4 [ RunTime:0.017665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32873041 ORDER BY `minOrder` ASC [ RunTime:0.017122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32873041 ORDER BY `unit` DESC [ RunTime:0.042337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32873041 LIMIT 2 [ RunTime:0.023109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32873041 ORDER BY `minOrder` ASC [ RunTime:0.032889s ]
select * from pdf where partno='210-856' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.021866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-856' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.014334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32873040 LIMIT 4 [ RunTime:0.014777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32873040 ORDER BY `minOrder` ASC [ RunTime:0.012553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32873040 ORDER BY `unit` DESC [ RunTime:0.046791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32873040 LIMIT 2 [ RunTime:0.007170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32873040 ORDER BY `minOrder` ASC [ RunTime:0.013872s ]
select * from pdf where partno='210-850' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.039445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-850' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.037906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32872668 LIMIT 4 [ RunTime:0.054271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32872668 ORDER BY `minOrder` ASC [ RunTime:0.019989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32872668 ORDER BY `unit` DESC [ RunTime:0.023513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32872668 LIMIT 2 [ RunTime:0.027796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32872668 ORDER BY `minOrder` ASC [ RunTime:0.003945s ]
select * from pdf where partno='210-854' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.004202s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-854' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.002681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32872585 LIMIT 4 [ RunTime:0.002529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32872585 ORDER BY `minOrder` ASC [ RunTime:0.007784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32872585 ORDER BY `unit` DESC [ RunTime:0.004527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32872585 LIMIT 2 [ RunTime:0.003545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32872585 ORDER BY `minOrder` ASC [ RunTime:0.007836s ]
select * from pdf where partno='210-860' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.015213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-860' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.008263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32872368 LIMIT 4 [ RunTime:0.007686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32872368 ORDER BY `minOrder` ASC [ RunTime:0.008768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32872368 ORDER BY `unit` DESC [ RunTime:0.018974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32872368 LIMIT 2 [ RunTime:0.030956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32872368 ORDER BY `minOrder` ASC [ RunTime:0.002777s ]
select * from pdf where partno='210-858' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.010329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-858' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.005894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32856387 LIMIT 4 [ RunTime:0.013982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32856387 ORDER BY `minOrder` ASC [ RunTime:0.003492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32856387 ORDER BY `unit` DESC [ RunTime:0.020347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32856387 LIMIT 2 [ RunTime:0.008548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32856387 ORDER BY `minOrder` ASC [ RunTime:0.012999s ]
select * from pdf where partno='210-837' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.019456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-837' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32856386 LIMIT 4 [ RunTime:0.048319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32856386 ORDER BY `minOrder` ASC [ RunTime:0.003910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32856386 ORDER BY `unit` DESC [ RunTime:0.004231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32856386 LIMIT 2 [ RunTime:0.026005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32856386 ORDER BY `minOrder` ASC [ RunTime:0.005332s ]
select * from pdf where partno='210-843' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.013077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-843' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.023715s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.009592s ]