SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002407s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=LP-GT&search=1' [ RunTime:0.004733s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002873s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000556s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002495s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.012564s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002277s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002628s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002240s ]
SELECT * FROM `stock_search` WHERE `partno` = 'LP-GT' LIMIT 1 [ RunTime:0.015402s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-26 03:53:55' WHERE `partno` = 'LP-GT' [ RunTime:0.022394s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002533s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LP-GT%' OR `brand` LIKE 'LP-GT%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018227s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13251834 LIMIT 5 [ RunTime:0.016386s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13251834 ORDER BY `minOrder` ASC [ RunTime:0.000925s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13251834 ORDER BY `unit` DESC [ RunTime:0.010546s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13251834 LIMIT 2 [ RunTime:0.004653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13251834 ORDER BY `minOrder` ASC [ RunTime:0.007428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11981466 LIMIT 5 [ RunTime:0.008937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11981466 ORDER BY `minOrder` ASC [ RunTime:0.007566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11981466 ORDER BY `unit` DESC [ RunTime:0.007500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11981466 LIMIT 2 [ RunTime:0.003902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11981466 ORDER BY `minOrder` ASC [ RunTime:0.004060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13253817 LIMIT 5 [ RunTime:0.006085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13253817 ORDER BY `minOrder` ASC [ RunTime:0.001037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13253817 ORDER BY `unit` DESC [ RunTime:0.009583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13253817 LIMIT 2 [ RunTime:0.003518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13253817 ORDER BY `minOrder` ASC [ RunTime:0.001109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252671 LIMIT 5 [ RunTime:0.004340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252671 ORDER BY `minOrder` ASC [ RunTime:0.005941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13252671 ORDER BY `unit` DESC [ RunTime:0.002784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13252671 LIMIT 2 [ RunTime:0.001257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252671 ORDER BY `minOrder` ASC [ RunTime:0.000678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252670 LIMIT 5 [ RunTime:0.000750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252670 ORDER BY `minOrder` ASC [ RunTime:0.003139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13252670 ORDER BY `unit` DESC [ RunTime:0.003275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13252670 LIMIT 2 [ RunTime:0.000952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252670 ORDER BY `minOrder` ASC [ RunTime:0.002798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252664 LIMIT 5 [ RunTime:0.002763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252664 ORDER BY `minOrder` ASC [ RunTime:0.001517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13252664 ORDER BY `unit` DESC [ RunTime:0.004423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13252664 LIMIT 2 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252664 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252652 LIMIT 5 [ RunTime:0.011406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252652 ORDER BY `minOrder` ASC [ RunTime:0.009502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13252652 ORDER BY `unit` DESC [ RunTime:0.006098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13252652 LIMIT 2 [ RunTime:0.002102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252652 ORDER BY `minOrder` ASC [ RunTime:0.028438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252634 LIMIT 5 [ RunTime:0.003689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252634 ORDER BY `minOrder` ASC [ RunTime:0.006454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13252634 ORDER BY `unit` DESC [ RunTime:0.008545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13252634 LIMIT 2 [ RunTime:0.009622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252634 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252448 LIMIT 5 [ RunTime:0.003367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252448 ORDER BY `minOrder` ASC [ RunTime:0.005524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13252448 ORDER BY `unit` DESC [ RunTime:0.003563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13252448 LIMIT 2 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252448 ORDER BY `minOrder` ASC [ RunTime:0.010457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252358 LIMIT 5 [ RunTime:0.012471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252358 ORDER BY `minOrder` ASC [ RunTime:0.019258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13252358 ORDER BY `unit` DESC [ RunTime:0.000641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13252358 LIMIT 2 [ RunTime:0.001874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252358 ORDER BY `minOrder` ASC [ RunTime:0.009398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252357 LIMIT 5 [ RunTime:0.006162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252357 ORDER BY `minOrder` ASC [ RunTime:0.000559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13252357 ORDER BY `unit` DESC [ RunTime:0.000481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13252357 LIMIT 2 [ RunTime:0.007445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13252357 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13251876 LIMIT 5 [ RunTime:0.000433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13251876 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13251876 ORDER BY `unit` DESC [ RunTime:0.001704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13251876 LIMIT 2 [ RunTime:0.012510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13251876 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13251875 LIMIT 5 [ RunTime:0.001119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13251875 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13251875 ORDER BY `unit` DESC [ RunTime:0.012041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13251875 LIMIT 2 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13251875 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13251837 LIMIT 5 [ RunTime:0.000503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13251837 ORDER BY `minOrder` ASC [ RunTime:0.001637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13251837 ORDER BY `unit` DESC [ RunTime:0.006599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13251837 LIMIT 2 [ RunTime:0.001431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13251837 ORDER BY `minOrder` ASC [ RunTime:0.003273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13251833 LIMIT 5 [ RunTime:0.002413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13251833 ORDER BY `minOrder` ASC [ RunTime:0.001761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13251833 ORDER BY `unit` DESC [ RunTime:0.002970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13251833 LIMIT 2 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13251833 ORDER BY `minOrder` ASC [ RunTime:0.001508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11981826 LIMIT 5 [ RunTime:0.010334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11981826 ORDER BY `minOrder` ASC [ RunTime:0.000560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11981826 ORDER BY `unit` DESC [ RunTime:0.007889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11981826 LIMIT 2 [ RunTime:0.002163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11981826 ORDER BY `minOrder` ASC [ RunTime:0.003100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11981824 LIMIT 5 [ RunTime:0.001699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11981824 ORDER BY `minOrder` ASC [ RunTime:0.001287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11981824 ORDER BY `unit` DESC [ RunTime:0.000517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11981824 LIMIT 2 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11981824 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11981823 LIMIT 5 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11981823 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11981823 ORDER BY `unit` DESC [ RunTime:0.009286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11981823 LIMIT 2 [ RunTime:0.002298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11981823 ORDER BY `minOrder` ASC [ RunTime:0.001116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11981772 LIMIT 5 [ RunTime:0.004520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11981772 ORDER BY `minOrder` ASC [ RunTime:0.005325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11981772 ORDER BY `unit` DESC [ RunTime:0.013730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11981772 LIMIT 2 [ RunTime:0.002611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11981772 ORDER BY `minOrder` ASC [ RunTime:0.000865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11981771 LIMIT 5 [ RunTime:0.004189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11981771 ORDER BY `minOrder` ASC [ RunTime:0.008396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11981771 ORDER BY `unit` DESC [ RunTime:0.022270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11981771 LIMIT 2 [ RunTime:0.003878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11981771 ORDER BY `minOrder` ASC [ RunTime:0.010335s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LP-GT%' OR `brand` LIKE 'LP-GT%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51089813 LIMIT 5 [ RunTime:0.007743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51089813 ORDER BY `minOrder` ASC [ RunTime:0.010756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51089813 ORDER BY `unit` DESC [ RunTime:0.004920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51089813 LIMIT 2 [ RunTime:0.001911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51089813 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='lp-gtd' and brandshort='amphenol times microwave systems' limit 1 [ RunTime:0.005250s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'lp-gtd' OR `brand` LIKE 'amphenol times microwave systems%' ) ) LIMIT 1 [ RunTime:0.014569s ]
SELECT `id` FROM `stock` WHERE `id` <> 51089813 AND `partno` = 'lp-gtd' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.007532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13251876 [ RunTime:0.000685s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LP-GT%' OR `brand` LIKE 'LP-GT%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64192442 LIMIT 5 [ RunTime:0.005923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64192442 ORDER BY `minOrder` ASC [ RunTime:0.021359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64192442 ORDER BY `unit` DESC [ RunTime:0.006796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64192442 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64192442 ORDER BY `minOrder` ASC [ RunTime:0.002231s ]
select * from pdf where partno='LP-GTR-NFF' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.007557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTR-NFF' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.029862s ]
SELECT `id` FROM `stock` WHERE `id` <> 64192442 AND `partno` = 'LP-GTR-NFF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.007611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64192491 LIMIT 5 [ RunTime:0.000774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64192491 ORDER BY `minOrder` ASC [ RunTime:0.000764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64192491 ORDER BY `unit` DESC [ RunTime:0.003874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64192491 LIMIT 2 [ RunTime:0.001884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64192491 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='LP-GTR-NFF-23' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.001153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTR-NFF-23' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.003771s ]
SELECT `id` FROM `stock` WHERE `id` <> 64192491 AND `partno` = 'LP-GTR-NFF-23' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.014079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13251837 [ RunTime:0.000763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64192487 LIMIT 5 [ RunTime:0.007947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64192487 ORDER BY `minOrder` ASC [ RunTime:0.010702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64192487 ORDER BY `unit` DESC [ RunTime:0.002731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64192487 LIMIT 2 [ RunTime:0.006387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64192487 ORDER BY `minOrder` ASC [ RunTime:0.015480s ]
select * from pdf where partno='LP-GTV-TFF' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.005725s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTV-TFF' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.001198s ]
SELECT `id` FROM `stock` WHERE `id` <> 64192487 AND `partno` = 'LP-GTV-TFF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.001408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11981466 [ RunTime:0.006976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64194942 LIMIT 5 [ RunTime:0.009356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194942 ORDER BY `minOrder` ASC [ RunTime:0.007830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64194942 ORDER BY `unit` DESC [ RunTime:0.002349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64194942 LIMIT 2 [ RunTime:0.010728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194942 ORDER BY `minOrder` ASC [ RunTime:0.001767s ]
select * from pdf where partno='LP-GTR-DFF' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.001580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTR-DFF' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.017351s ]
SELECT `id` FROM `stock` WHERE `id` <> 64194942 AND `partno` = 'LP-GTR-DFF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.013199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64194898 LIMIT 5 [ RunTime:0.007955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194898 ORDER BY `minOrder` ASC [ RunTime:0.003397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64194898 ORDER BY `unit` DESC [ RunTime:0.020350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64194898 LIMIT 2 [ RunTime:0.026093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194898 ORDER BY `minOrder` ASC [ RunTime:0.018498s ]
select * from pdf where partno='LP-GTR-DFF-23' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.001141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTR-DFF-23' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.013808s ]
SELECT `id` FROM `stock` WHERE `id` <> 64194898 AND `partno` = 'LP-GTR-DFF-23' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.006983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252671 [ RunTime:0.009592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64194897 LIMIT 5 [ RunTime:0.011984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194897 ORDER BY `minOrder` ASC [ RunTime:0.020206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64194897 ORDER BY `unit` DESC [ RunTime:0.002012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64194897 LIMIT 2 [ RunTime:0.000519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194897 ORDER BY `minOrder` ASC [ RunTime:0.022509s ]
select * from pdf where partno='LP-GTR-DFM-35' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.003514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTR-DFM-35' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.010809s ]
SELECT `id` FROM `stock` WHERE `id` <> 64194897 AND `partno` = 'LP-GTR-DFM-35' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.012069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252670 [ RunTime:0.036499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64194891 LIMIT 5 [ RunTime:0.009912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194891 ORDER BY `minOrder` ASC [ RunTime:0.011315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64194891 ORDER BY `unit` DESC [ RunTime:0.009546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64194891 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194891 ORDER BY `minOrder` ASC [ RunTime:0.003375s ]
select * from pdf where partno='LP-GTR-DFM-23' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.002967s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTR-DFM-23' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.001118s ]
SELECT `id` FROM `stock` WHERE `id` <> 64194891 AND `partno` = 'LP-GTR-DFM-23' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.000859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252664 [ RunTime:0.003416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64194881 LIMIT 5 [ RunTime:0.006098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194881 ORDER BY `minOrder` ASC [ RunTime:0.010578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64194881 ORDER BY `unit` DESC [ RunTime:0.002809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64194881 LIMIT 2 [ RunTime:0.002488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194881 ORDER BY `minOrder` ASC [ RunTime:0.003467s ]
select * from pdf where partno='LP-GTR-NFF-35' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.003681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTR-NFF-35' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.000841s ]
SELECT `id` FROM `stock` WHERE `id` <> 64194881 AND `partno` = 'LP-GTR-NFF-35' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.002180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252652 [ RunTime:0.003224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64194842 LIMIT 5 [ RunTime:0.008643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194842 ORDER BY `minOrder` ASC [ RunTime:0.004026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64194842 ORDER BY `unit` DESC [ RunTime:0.000455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64194842 LIMIT 2 [ RunTime:0.000348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194842 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
select * from pdf where partno='LP-GTR-DFF-35' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.003281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTR-DFF-35' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.000590s ]
SELECT `id` FROM `stock` WHERE `id` <> 64194842 AND `partno` = 'LP-GTR-DFF-35' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.006372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252634 [ RunTime:0.001690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64194367 LIMIT 5 [ RunTime:0.014483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194367 ORDER BY `minOrder` ASC [ RunTime:0.004486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64194367 ORDER BY `unit` DESC [ RunTime:0.001974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64194367 LIMIT 2 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194367 ORDER BY `minOrder` ASC [ RunTime:0.001690s ]
select * from pdf where partno='LP-GTV-SFF' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.000856s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTV-SFF' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.003429s ]
SELECT `id` FROM `stock` WHERE `id` <> 64194367 AND `partno` = 'LP-GTV-SFF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.005296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252448 [ RunTime:0.001665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64194244 LIMIT 5 [ RunTime:0.000458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194244 ORDER BY `minOrder` ASC [ RunTime:0.000810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64194244 ORDER BY `unit` DESC [ RunTime:0.000369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64194244 LIMIT 2 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194244 ORDER BY `minOrder` ASC [ RunTime:0.001988s ]
select * from pdf where partno='LP-GTV-RTF' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.000841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTV-RTF' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.000727s ]
SELECT `id` FROM `stock` WHERE `id` <> 64194244 AND `partno` = 'LP-GTV-RTF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.008293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11981772 [ RunTime:0.001673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64194243 LIMIT 5 [ RunTime:0.000849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194243 ORDER BY `minOrder` ASC [ RunTime:0.003381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64194243 ORDER BY `unit` DESC [ RunTime:0.003663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64194243 LIMIT 2 [ RunTime:0.002008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64194243 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
select * from pdf where partno='LP-GTV-RTFM' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.001569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTV-RTFM' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.000542s ]
SELECT `id` FROM `stock` WHERE `id` <> 64194243 AND `partno` = 'LP-GTV-RTFM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.000522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11981771 [ RunTime:0.002142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64193393 LIMIT 5 [ RunTime:0.002773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64193393 ORDER BY `minOrder` ASC [ RunTime:0.001771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64193393 ORDER BY `unit` DESC [ RunTime:0.002125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64193393 LIMIT 2 [ RunTime:0.011470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64193393 ORDER BY `minOrder` ASC [ RunTime:0.016133s ]
select * from pdf where partno='LP-GTD-23' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.002848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTD-23' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.000486s ]
SELECT `id` FROM `stock` WHERE `id` <> 64193393 AND `partno` = 'LP-GTD-23' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.004147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11981490 [ RunTime:0.001740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64193392 LIMIT 5 [ RunTime:0.010372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64193392 ORDER BY `minOrder` ASC [ RunTime:0.008893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64193392 ORDER BY `unit` DESC [ RunTime:0.001637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64193392 LIMIT 2 [ RunTime:0.004715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64193392 ORDER BY `minOrder` ASC [ RunTime:0.005876s ]
select * from pdf where partno='LP-GTD' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.002467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTD' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.006943s ]
SELECT `id` FROM `stock` WHERE `id` <> 64193392 AND `partno` = 'LP-GTD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.032144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13251876 [ RunTime:0.008112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64193391 LIMIT 5 [ RunTime:0.002864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64193391 ORDER BY `minOrder` ASC [ RunTime:0.011061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64193391 ORDER BY `unit` DESC [ RunTime:0.006882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64193391 LIMIT 2 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64193391 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
select * from pdf where partno='LP-GT-23' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.000878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GT-23' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.005589s ]
SELECT `id` FROM `stock` WHERE `id` <> 64193391 AND `partno` = 'LP-GT-23' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.017659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13251875 [ RunTime:0.001729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64193390 LIMIT 5 [ RunTime:0.014675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64193390 ORDER BY `minOrder` ASC [ RunTime:0.005641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64193390 ORDER BY `unit` DESC [ RunTime:0.003531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64193390 LIMIT 2 [ RunTime:0.002289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64193390 ORDER BY `minOrder` ASC [ RunTime:0.011354s ]
select * from pdf where partno='LP-GT' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.014268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GT' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.000892s ]
SELECT `id` FROM `stock` WHERE `id` <> 64193390 AND `partno` = 'LP-GT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.000818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11981489 [ RunTime:0.001510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64193389 LIMIT 5 [ RunTime:0.003303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64193389 ORDER BY `minOrder` ASC [ RunTime:0.025644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64193389 ORDER BY `unit` DESC [ RunTime:0.004609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64193389 LIMIT 2 [ RunTime:0.001366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64193389 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
select * from pdf where partno='LP-GT-35' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.000821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GT-35' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.000808s ]
SELECT `id` FROM `stock` WHERE `id` <> 64193389 AND `partno` = 'LP-GT-35' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.012550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64193308 LIMIT 5 [ RunTime:0.012580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64193308 ORDER BY `minOrder` ASC [ RunTime:0.003068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64193308 ORDER BY `unit` DESC [ RunTime:0.011240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64193308 LIMIT 2 [ RunTime:0.003395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64193308 ORDER BY `minOrder` ASC [ RunTime:0.002297s ]
select * from pdf where partno='LP-GTD-35' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.005961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTD-35' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.020726s ]
SELECT `id` FROM `stock` WHERE `id` <> 64193308 AND `partno` = 'LP-GTD-35' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.034352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13253817 [ RunTime:0.050544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64193097 LIMIT 5 [ RunTime:0.008678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64193097 ORDER BY `minOrder` ASC [ RunTime:0.020273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64193097 ORDER BY `unit` DESC [ RunTime:0.012077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64193097 LIMIT 2 [ RunTime:0.024666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64193097 ORDER BY `minOrder` ASC [ RunTime:0.003125s ]
select * from pdf where partno='LP-GTR-NFM-35' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.017722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTR-NFM-35' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.019603s ]
SELECT `id` FROM `stock` WHERE `id` <> 64193097 AND `partno` = 'LP-GTR-NFM-35' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.007527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64192527 LIMIT 5 [ RunTime:0.010017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64192527 ORDER BY `minOrder` ASC [ RunTime:0.006485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64192527 ORDER BY `unit` DESC [ RunTime:0.030016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64192527 LIMIT 2 [ RunTime:0.013913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64192527 ORDER BY `minOrder` ASC [ RunTime:0.002385s ]
select * from pdf where partno='LP-GTR-DFM' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.011031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP-GTR-DFM' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.010340s ]
SELECT `id` FROM `stock` WHERE `id` <> 64192527 AND `partno` = 'LP-GTR-DFM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.029223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13252358 [ RunTime:0.012352s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LP-GT%' OR `brand` LIKE 'LP-GT%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017350s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LP-GT%' OR `brand` LIKE 'LP-GT%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027223s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LP-GT%' OR `brand` LIKE 'LP-GT%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029465s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LP-GT%' OR `brand` LIKE 'LP-GT%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009310s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LP-GT%' OR `brand` LIKE 'LP-GT%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027008s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LP-GT%' OR `brand` LIKE 'LP-GT%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042443s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LP-GT%' OR `brand` LIKE 'LP-GT%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062602s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LP-GT%' OR `brand` LIKE 'LP-GT%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.077222s ]