SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001963s ]
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 'V4-1.5-0-SP-SM%' OR `brand` LIKE 'V4-1.5-0-SP-SM%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025688s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13558778 LIMIT 5 [ RunTime:0.008985s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13558778 ORDER BY `minOrder` ASC [ RunTime:0.033860s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.029337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13558778 ORDER BY `unit` DESC [ RunTime:0.006877s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13558778 LIMIT 2 [ RunTime:0.019763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13558778 ORDER BY `minOrder` ASC [ RunTime:0.023867s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.008273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16436396 LIMIT 5 [ RunTime:0.012448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16436396 ORDER BY `minOrder` ASC [ RunTime:0.005978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16436396 ORDER BY `unit` DESC [ RunTime:0.014481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16436396 LIMIT 2 [ RunTime:0.013109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16436396 ORDER BY `minOrder` ASC [ RunTime:0.006731s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.007115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16439236 LIMIT 5 [ RunTime:0.026702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16439236 ORDER BY `minOrder` ASC [ RunTime:0.035151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16439236 ORDER BY `unit` DESC [ RunTime:0.043960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16439236 LIMIT 2 [ RunTime:0.016046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16439236 ORDER BY `minOrder` ASC [ RunTime:0.006654s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.006260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16437856 LIMIT 5 [ RunTime:0.007578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16437856 ORDER BY `minOrder` ASC [ RunTime:0.008717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16437856 ORDER BY `unit` DESC [ RunTime:0.007588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16437856 LIMIT 2 [ RunTime:0.012490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16437856 ORDER BY `minOrder` ASC [ RunTime:0.031282s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.008701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16437824 LIMIT 5 [ RunTime:0.017751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16437824 ORDER BY `minOrder` ASC [ RunTime:0.044419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16437824 ORDER BY `unit` DESC [ RunTime:0.006356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16437824 LIMIT 2 [ RunTime:0.011921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16437824 ORDER BY `minOrder` ASC [ RunTime:0.006082s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.005086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16437823 LIMIT 5 [ RunTime:0.022501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16437823 ORDER BY `minOrder` ASC [ RunTime:0.009177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16437823 ORDER BY `unit` DESC [ RunTime:0.013609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16437823 LIMIT 2 [ RunTime:0.005724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16437823 ORDER BY `minOrder` ASC [ RunTime:0.002686s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14429779 LIMIT 5 [ RunTime:0.003234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14429779 ORDER BY `minOrder` ASC [ RunTime:0.009165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14429779 ORDER BY `unit` DESC [ RunTime:0.009479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14429779 LIMIT 2 [ RunTime:0.020673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14429779 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14429550 LIMIT 5 [ RunTime:0.005382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14429550 ORDER BY `minOrder` ASC [ RunTime:0.010453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14429550 ORDER BY `unit` DESC [ RunTime:0.002753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14429550 LIMIT 2 [ RunTime:0.002045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14429550 ORDER BY `minOrder` ASC [ RunTime:0.005617s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.002845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14428574 LIMIT 5 [ RunTime:0.009413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428574 ORDER BY `minOrder` ASC [ RunTime:0.005794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14428574 ORDER BY `unit` DESC [ RunTime:0.005341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14428574 LIMIT 2 [ RunTime:0.003294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428574 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.002287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13561190 LIMIT 5 [ RunTime:0.001104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13561190 ORDER BY `minOrder` ASC [ RunTime:0.003086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13561190 ORDER BY `unit` DESC [ RunTime:0.007082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13561190 LIMIT 2 [ RunTime:0.019755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13561190 ORDER BY `minOrder` ASC [ RunTime:0.002338s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.006216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13560141 LIMIT 5 [ RunTime:0.018951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13560141 ORDER BY `minOrder` ASC [ RunTime:0.010103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13560141 ORDER BY `unit` DESC [ RunTime:0.012181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13560141 LIMIT 2 [ RunTime:0.008212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13560141 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13559689 LIMIT 5 [ RunTime:0.010723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559689 ORDER BY `minOrder` ASC [ RunTime:0.009520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13559689 ORDER BY `unit` DESC [ RunTime:0.002012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13559689 LIMIT 2 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559689 ORDER BY `minOrder` ASC [ RunTime:0.010603s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13559528 LIMIT 5 [ RunTime:0.001964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559528 ORDER BY `minOrder` ASC [ RunTime:0.003711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13559528 ORDER BY `unit` DESC [ RunTime:0.002014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13559528 LIMIT 2 [ RunTime:0.003380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559528 ORDER BY `minOrder` ASC [ RunTime:0.002410s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13559456 LIMIT 5 [ RunTime:0.012911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559456 ORDER BY `minOrder` ASC [ RunTime:0.003784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13559456 ORDER BY `unit` DESC [ RunTime:0.001559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13559456 LIMIT 2 [ RunTime:0.004660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559456 ORDER BY `minOrder` ASC [ RunTime:0.000735s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13559455 LIMIT 5 [ RunTime:0.001598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559455 ORDER BY `minOrder` ASC [ RunTime:0.000748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13559455 ORDER BY `unit` DESC [ RunTime:0.000647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13559455 LIMIT 2 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559455 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000508s ]
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 'V4-1.5-0-SP-SM%' OR `brand` LIKE 'V4-1.5-0-SP-SM%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007867s ]
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 'V4-1.5-0-SP-SM%' OR `brand` LIKE 'V4-1.5-0-SP-SM%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36473520 LIMIT 5 [ RunTime:0.000821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36473520 ORDER BY `minOrder` ASC [ RunTime:0.007134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36473520 ORDER BY `unit` DESC [ RunTime:0.011288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36473520 LIMIT 2 [ RunTime:0.000896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36473520 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000632s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V4-1.5-0-SP-SM' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.001541s ]
SELECT `id` FROM `stock` WHERE `id` <> 36473520 AND `partno` = 'V4-1.5-0-SP-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.004506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13558778 [ RunTime:0.001757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49271481 LIMIT 5 [ RunTime:0.004459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49271481 ORDER BY `minOrder` ASC [ RunTime:0.006485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49271481 ORDER BY `unit` DESC [ RunTime:0.006680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49271481 LIMIT 2 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49271481 ORDER BY `minOrder` ASC [ RunTime:0.003522s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.005385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V4-1.5-0-SP-SM' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.000445s ]
SELECT `id` FROM `stock` WHERE `id` <> 49271481 AND `partno` = 'V4-1.5-0-SP-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.001520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13558778 [ RunTime:0.000499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36474265 LIMIT 5 [ RunTime:0.015354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36474265 ORDER BY `minOrder` ASC [ RunTime:0.012685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36474265 ORDER BY `unit` DESC [ RunTime:0.035895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36474265 LIMIT 2 [ RunTime:0.007664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36474265 ORDER BY `minOrder` ASC [ RunTime:0.024210s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.003057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V4-1.5-0-SP-SM' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.028887s ]
SELECT `id` FROM `stock` WHERE `id` <> 36474265 AND `partno` = 'V4-1.5-0-SP-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.041626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13558778 [ RunTime:0.006077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49270794 LIMIT 5 [ RunTime:0.001104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49270794 ORDER BY `minOrder` ASC [ RunTime:0.001294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49270794 ORDER BY `unit` DESC [ RunTime:0.004816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49270794 LIMIT 2 [ RunTime:0.000870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49270794 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V4-1.5-0-SP-SM' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.000440s ]
SELECT `id` FROM `stock` WHERE `id` <> 49270794 AND `partno` = 'V4-1.5-0-SP-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.001286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13558778 [ RunTime:0.000419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49275723 LIMIT 5 [ RunTime:0.001326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49275723 ORDER BY `minOrder` ASC [ RunTime:0.002978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49275723 ORDER BY `unit` DESC [ RunTime:0.007131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49275723 LIMIT 2 [ RunTime:0.000862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49275723 ORDER BY `minOrder` ASC [ RunTime:0.003757s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V4-1.5-0-SP-SM' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002949s ]
SELECT `id` FROM `stock` WHERE `id` <> 49275723 AND `partno` = 'V4-1.5-0-SP-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36479152 [ RunTime:0.010907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36479152 LIMIT 5 [ RunTime:0.000933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36479152 ORDER BY `minOrder` ASC [ RunTime:0.004388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36479152 ORDER BY `unit` DESC [ RunTime:0.004106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36479152 LIMIT 2 [ RunTime:0.010446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36479152 ORDER BY `minOrder` ASC [ RunTime:0.000480s ]
select * from pdf where partno='V4-1.5-0-SP-SM' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000590s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V4-1.5-0-SP-SM' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000601s ]
SELECT `id` FROM `stock` WHERE `id` <> 36479152 AND `partno` = 'V4-1.5-0-SP-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49275723 [ RunTime:0.006104s ]
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 'V4-1.5-0-SP-SM%' OR `brand` LIKE 'V4-1.5-0-SP-SM%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011473s ]
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 'V4-1.5-0-SP-SM%' OR `brand` LIKE 'V4-1.5-0-SP-SM%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006736s ]
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 'V4-1.5-0-SP-SM%' OR `brand` LIKE 'V4-1.5-0-SP-SM%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003068s ]
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 'V4-1.5-0-SP-SM%' OR `brand` LIKE 'V4-1.5-0-SP-SM%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022355s ]
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 'V4-1.5-0-SP-SM%' OR `brand` LIKE 'V4-1.5-0-SP-SM%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006666s ]
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 'V4-1.5-0-SP-SM%' OR `brand` LIKE 'V4-1.5-0-SP-SM%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004020s ]
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 'V4-1.5-0-SP-SM%' OR `brand` LIKE 'V4-1.5-0-SP-SM%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004503s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'V4-1.5-0-SP-SM%' OR `brand` LIKE 'V4-1.5-0-SP-SM%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003725s ]