SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003054s ]
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 '1914%' OR `brand` LIKE '1914%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020928s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13498298 LIMIT 5 [ RunTime:0.011989s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13498298 ORDER BY `minOrder` ASC [ RunTime:0.013011s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13498298 ORDER BY `unit` DESC [ RunTime:0.023969s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13498298 LIMIT 2 [ RunTime:0.004920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13498298 ORDER BY `minOrder` ASC [ RunTime:0.006504s ]
select * from pdf where partno='19140 010250' and brandshort='Belden Inc.' limit 1 [ RunTime:0.020573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583034 LIMIT 5 [ RunTime:0.004905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583034 ORDER BY `minOrder` ASC [ RunTime:0.010419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583034 ORDER BY `unit` DESC [ RunTime:0.003449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583034 LIMIT 2 [ RunTime:0.002231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583034 ORDER BY `minOrder` ASC [ RunTime:0.008189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11486611 LIMIT 5 [ RunTime:0.031012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11486611 ORDER BY `minOrder` ASC [ RunTime:0.015899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11486611 ORDER BY `unit` DESC [ RunTime:0.008449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11486611 LIMIT 2 [ RunTime:0.008068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11486611 ORDER BY `minOrder` ASC [ RunTime:0.031273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12061278 LIMIT 5 [ RunTime:0.034737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12061278 ORDER BY `minOrder` ASC [ RunTime:0.022470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12061278 ORDER BY `unit` DESC [ RunTime:0.009034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12061278 LIMIT 2 [ RunTime:0.020615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12061278 ORDER BY `minOrder` ASC [ RunTime:0.000735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20123384 LIMIT 5 [ RunTime:0.024934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20123384 ORDER BY `minOrder` ASC [ RunTime:0.027683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20123384 ORDER BY `unit` DESC [ RunTime:0.019679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20123384 LIMIT 2 [ RunTime:0.008843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20123384 ORDER BY `minOrder` ASC [ RunTime:0.018422s ]
select * from pdf where partno='19140010402' and brandshort='HARTING' limit 1 [ RunTime:0.016259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12061986 LIMIT 5 [ RunTime:0.024773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12061986 ORDER BY `minOrder` ASC [ RunTime:0.020203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12061986 ORDER BY `unit` DESC [ RunTime:0.046415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12061986 LIMIT 2 [ RunTime:0.014603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12061986 ORDER BY `minOrder` ASC [ RunTime:0.015174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066300 LIMIT 5 [ RunTime:0.019916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066300 ORDER BY `minOrder` ASC [ RunTime:0.053783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12066300 ORDER BY `unit` DESC [ RunTime:0.025189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12066300 LIMIT 2 [ RunTime:0.005621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066300 ORDER BY `minOrder` ASC [ RunTime:0.021351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12544251 LIMIT 5 [ RunTime:0.034186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544251 ORDER BY `minOrder` ASC [ RunTime:0.054801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12544251 ORDER BY `unit` DESC [ RunTime:0.031797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12544251 LIMIT 2 [ RunTime:0.029306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544251 ORDER BY `minOrder` ASC [ RunTime:0.000551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15561232 LIMIT 5 [ RunTime:0.020621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15561232 ORDER BY `minOrder` ASC [ RunTime:0.012757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15561232 ORDER BY `unit` DESC [ RunTime:0.038652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15561232 LIMIT 2 [ RunTime:0.005395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15561232 ORDER BY `minOrder` ASC [ RunTime:0.005400s ]
select * from pdf where partno='19140020400' and brandshort='HARTING' limit 1 [ RunTime:0.020952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17289969 LIMIT 5 [ RunTime:0.022511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17289969 ORDER BY `minOrder` ASC [ RunTime:0.012449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17289969 ORDER BY `unit` DESC [ RunTime:0.009185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17289969 LIMIT 2 [ RunTime:0.003247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17289969 ORDER BY `minOrder` ASC [ RunTime:0.018606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556588 LIMIT 5 [ RunTime:0.024106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556588 ORDER BY `minOrder` ASC [ RunTime:0.023347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12556588 ORDER BY `unit` DESC [ RunTime:0.015667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12556588 LIMIT 2 [ RunTime:0.033443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556588 ORDER BY `minOrder` ASC [ RunTime:0.007459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556409 LIMIT 5 [ RunTime:0.037099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556409 ORDER BY `minOrder` ASC [ RunTime:0.012551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12556409 ORDER BY `unit` DESC [ RunTime:0.024320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12556409 LIMIT 2 [ RunTime:0.092232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556409 ORDER BY `minOrder` ASC [ RunTime:0.009481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11442817 LIMIT 5 [ RunTime:0.039105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442817 ORDER BY `minOrder` ASC [ RunTime:0.055263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11442817 ORDER BY `unit` DESC [ RunTime:0.010300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11442817 LIMIT 2 [ RunTime:0.029817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442817 ORDER BY `minOrder` ASC [ RunTime:0.020500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11442813 LIMIT 5 [ RunTime:0.022279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442813 ORDER BY `minOrder` ASC [ RunTime:0.026959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11442813 ORDER BY `unit` DESC [ RunTime:0.047259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11442813 LIMIT 2 [ RunTime:0.025059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442813 ORDER BY `minOrder` ASC [ RunTime:0.003370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11442796 LIMIT 5 [ RunTime:0.018258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442796 ORDER BY `minOrder` ASC [ RunTime:0.020167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11442796 ORDER BY `unit` DESC [ RunTime:0.019611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11442796 LIMIT 2 [ RunTime:0.064046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442796 ORDER BY `minOrder` ASC [ RunTime:0.005536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11442478 LIMIT 5 [ RunTime:0.012633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442478 ORDER BY `minOrder` ASC [ RunTime:0.011285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11442478 ORDER BY `unit` DESC [ RunTime:0.031825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11442478 LIMIT 2 [ RunTime:0.021547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442478 ORDER BY `minOrder` ASC [ RunTime:0.022253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20123617 LIMIT 5 [ RunTime:0.009475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20123617 ORDER BY `minOrder` ASC [ RunTime:0.009953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20123617 ORDER BY `unit` DESC [ RunTime:0.006336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20123617 LIMIT 2 [ RunTime:0.012538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20123617 ORDER BY `minOrder` ASC [ RunTime:0.000997s ]
select * from pdf where partno='19140010501' and brandshort='HARTING' limit 1 [ RunTime:0.000774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556383 LIMIT 5 [ RunTime:0.017197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556383 ORDER BY `minOrder` ASC [ RunTime:0.025525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12556383 ORDER BY `unit` DESC [ RunTime:0.068923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12556383 LIMIT 2 [ RunTime:0.032822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556383 ORDER BY `minOrder` ASC [ RunTime:0.002227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15561366 LIMIT 5 [ RunTime:0.003576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15561366 ORDER BY `minOrder` ASC [ RunTime:0.013530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15561366 ORDER BY `unit` DESC [ RunTime:0.011320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15561366 LIMIT 2 [ RunTime:0.012027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15561366 ORDER BY `minOrder` ASC [ RunTime:0.009786s ]
select * from pdf where partno='19140010401' and brandshort='HARTING' limit 1 [ RunTime:0.012742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13107489 LIMIT 5 [ RunTime:0.003070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107489 ORDER BY `minOrder` ASC [ RunTime:0.014217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13107489 ORDER BY `unit` DESC [ RunTime:0.041885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13107489 LIMIT 2 [ RunTime:0.009964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107489 ORDER BY `minOrder` ASC [ RunTime:0.004556s ]
select * from pdf where partno='19140010403' and brandshort='HARTING' limit 1 [ RunTime:0.015153s ]
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 '1914%' OR `brand` LIKE '1914%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282137 LIMIT 5 [ RunTime:0.041073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282137 ORDER BY `minOrder` ASC [ RunTime:0.011770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282137 ORDER BY `unit` DESC [ RunTime:0.006111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282137 LIMIT 2 [ RunTime:0.017408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282137 ORDER BY `minOrder` ASC [ RunTime:0.003882s ]
select * from pdf where partno='19142-0020' and brandshort='molex' limit 1 [ RunTime:0.010362s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19142-0020' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.006594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212553 LIMIT 5 [ RunTime:0.008613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212553 ORDER BY `minOrder` ASC [ RunTime:0.023179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32212553 ORDER BY `unit` DESC [ RunTime:0.000979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32212553 LIMIT 2 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212553 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
select * from pdf where partno='1914n' and brandshort='electroswitch' limit 1 [ RunTime:0.001692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1914n' OR `brand` LIKE 'electroswitch%' ) ) LIMIT 1 [ RunTime:0.002009s ]
SELECT `id` FROM `stock` WHERE `id` <> 32212553 AND `partno` = '1914n' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%electroswitch%' ) [ RunTime:0.003519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17289969 [ RunTime:0.003940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276381 LIMIT 5 [ RunTime:0.000660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276381 ORDER BY `minOrder` ASC [ RunTime:0.005862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276381 ORDER BY `unit` DESC [ RunTime:0.011065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276381 LIMIT 2 [ RunTime:0.004827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276381 ORDER BY `minOrder` ASC [ RunTime:0.013857s ]
select * from pdf where partno='1914205' and brandshort='phoenix contact' limit 1 [ RunTime:0.001207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1914205' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.000523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276143 LIMIT 5 [ RunTime:0.005284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276143 ORDER BY `minOrder` ASC [ RunTime:0.001819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276143 ORDER BY `unit` DESC [ RunTime:0.000603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276143 LIMIT 2 [ RunTime:0.006051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276143 ORDER BY `minOrder` ASC [ RunTime:0.001919s ]
select * from pdf where partno='1914030' and brandshort='phoenix contact' limit 1 [ RunTime:0.014205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1914030' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.009296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51072495 LIMIT 5 [ RunTime:0.028060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51072495 ORDER BY `minOrder` ASC [ RunTime:0.006710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51072495 ORDER BY `unit` DESC [ RunTime:0.006626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51072495 LIMIT 2 [ RunTime:0.005118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51072495 ORDER BY `minOrder` ASC [ RunTime:0.002991s ]
select * from pdf where partno='19145' and brandshort='vicor' limit 1 [ RunTime:0.001610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19145' OR `brand` LIKE 'vicor%' ) ) LIMIT 1 [ RunTime:0.006290s ]
SELECT `id` FROM `stock` WHERE `id` <> 51072495 AND `partno` = '19145' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor%' ) [ RunTime:0.009487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12049355 [ RunTime:0.004260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51072192 LIMIT 5 [ RunTime:0.001562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51072192 ORDER BY `minOrder` ASC [ RunTime:0.004097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51072192 ORDER BY `unit` DESC [ RunTime:0.002459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51072192 LIMIT 2 [ RunTime:0.008438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51072192 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
select * from pdf where partno='19141' and brandshort='vicor' limit 1 [ RunTime:0.001408s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19141' OR `brand` LIKE 'vicor%' ) ) LIMIT 1 [ RunTime:0.006941s ]
SELECT `id` FROM `stock` WHERE `id` <> 51072192 AND `partno` = '19141' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor%' ) [ RunTime:0.003158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12049351 [ RunTime:0.002745s ]
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 '1914%' OR `brand` LIKE '1914%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49174764 LIMIT 5 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49174764 ORDER BY `minOrder` ASC [ RunTime:0.005662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49174764 ORDER BY `unit` DESC [ RunTime:0.003392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49174764 LIMIT 2 [ RunTime:0.018179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49174764 ORDER BY `minOrder` ASC [ RunTime:0.002670s ]
select * from pdf where partno='19140 010250' and brandshort='Belden Inc.' limit 1 [ RunTime:0.003384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19140 010250' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.002011s ]
SELECT `id` FROM `stock` WHERE `id` <> 49174764 AND `partno` = '19140 010250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.001333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13498298 [ RunTime:0.000854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36378478 LIMIT 5 [ RunTime:0.006665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36378478 ORDER BY `minOrder` ASC [ RunTime:0.002323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36378478 ORDER BY `unit` DESC [ RunTime:0.007300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36378478 LIMIT 2 [ RunTime:0.000873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36378478 ORDER BY `minOrder` ASC [ RunTime:0.000591s ]
select * from pdf where partno='19140 010250' and brandshort='Belden Inc.' limit 1 [ RunTime:0.006245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19140 010250' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.005149s ]
SELECT `id` FROM `stock` WHERE `id` <> 36378478 AND `partno` = '19140 010250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.004285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13498298 [ RunTime:0.004067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50736709 LIMIT 5 [ RunTime:0.013818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50736709 ORDER BY `minOrder` ASC [ RunTime:0.021945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50736709 ORDER BY `unit` DESC [ RunTime:0.015119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50736709 LIMIT 2 [ RunTime:0.019328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50736709 ORDER BY `minOrder` ASC [ RunTime:0.001875s ]
select * from pdf where partno='1914CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.010811s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1914CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.018198s ]
SELECT `id` FROM `stock` WHERE `id` <> 50736709 AND `partno` = '1914CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.015793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066300 [ RunTime:0.008542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38137020 LIMIT 5 [ RunTime:0.006526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38137020 ORDER BY `minOrder` ASC [ RunTime:0.013824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38137020 ORDER BY `unit` DESC [ RunTime:0.001711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38137020 LIMIT 2 [ RunTime:0.001716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38137020 ORDER BY `minOrder` ASC [ RunTime:0.001331s ]
select * from pdf where partno='1914CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1914CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000446s ]
SELECT `id` FROM `stock` WHERE `id` <> 38137020 AND `partno` = '1914CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.005084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066300 [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36415778 LIMIT 5 [ RunTime:0.003866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36415778 ORDER BY `minOrder` ASC [ RunTime:0.017179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36415778 ORDER BY `unit` DESC [ RunTime:0.018677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36415778 LIMIT 2 [ RunTime:0.006751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36415778 ORDER BY `minOrder` ASC [ RunTime:0.002816s ]
select * from pdf where partno='19140 010250' and brandshort='Belden Inc.' limit 1 [ RunTime:0.002050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19140 010250' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.001409s ]
SELECT `id` FROM `stock` WHERE `id` <> 36415778 AND `partno` = '19140 010250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13498298 [ RunTime:0.000294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53086478 LIMIT 5 [ RunTime:0.002081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53086478 ORDER BY `minOrder` ASC [ RunTime:0.009265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53086478 ORDER BY `unit` DESC [ RunTime:0.001473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53086478 LIMIT 2 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53086478 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
select * from pdf where partno='1914' and brandshort='Pololu' limit 1 [ RunTime:0.000934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1914' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.004183s ]
SELECT `id` FROM `stock` WHERE `id` <> 53086478 AND `partno` = '1914' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.003705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11486611 [ RunTime:0.003750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53577840 LIMIT 5 [ RunTime:0.004500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53577840 ORDER BY `minOrder` ASC [ RunTime:0.012444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53577840 ORDER BY `unit` DESC [ RunTime:0.003623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53577840 LIMIT 2 [ RunTime:0.007804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53577840 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='19140010401' and brandshort='HARTING' limit 1 [ RunTime:0.004166s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19140010401' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.000577s ]
SELECT `id` FROM `stock` WHERE `id` <> 53577840 AND `partno` = '19140010401' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.007868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15561366 [ RunTime:0.018683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49538456 LIMIT 5 [ RunTime:0.003932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49538456 ORDER BY `minOrder` ASC [ RunTime:0.003186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49538456 ORDER BY `unit` DESC [ RunTime:0.011644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49538456 LIMIT 2 [ RunTime:0.006412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49538456 ORDER BY `minOrder` ASC [ RunTime:0.004376s ]
select * from pdf where partno='1914-N' and brandshort='Davies Molding, LLC' limit 1 [ RunTime:0.057368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1914-N' OR `brand` LIKE 'Davies Molding, LLC%' ) ) LIMIT 1 [ RunTime:0.008356s ]
SELECT `id` FROM `stock` WHERE `id` <> 49538456 AND `partno` = '1914-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%davies molding, llc%' ) [ RunTime:0.003274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12061278 [ RunTime:0.000596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36731895 LIMIT 5 [ RunTime:0.006704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36731895 ORDER BY `minOrder` ASC [ RunTime:0.009982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36731895 ORDER BY `unit` DESC [ RunTime:0.016273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36731895 LIMIT 2 [ RunTime:0.017022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36731895 ORDER BY `minOrder` ASC [ RunTime:0.001997s ]
select * from pdf where partno='1914-N' and brandshort='Davies Molding, LLC' limit 1 [ RunTime:0.003373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1914-N' OR `brand` LIKE 'Davies Molding, LLC%' ) ) LIMIT 1 [ RunTime:0.001680s ]
SELECT `id` FROM `stock` WHERE `id` <> 36731895 AND `partno` = '1914-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%davies molding, llc%' ) [ RunTime:0.005694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12061278 [ RunTime:0.009282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53577884 LIMIT 5 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53577884 ORDER BY `minOrder` ASC [ RunTime:0.004772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53577884 ORDER BY `unit` DESC [ RunTime:0.000499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53577884 LIMIT 2 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53577884 ORDER BY `minOrder` ASC [ RunTime:0.005259s ]
select * from pdf where partno='19140010501' and brandshort='HARTING' limit 1 [ RunTime:0.001493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19140010501' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.002160s ]
SELECT `id` FROM `stock` WHERE `id` <> 53577884 AND `partno` = '19140010501' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.000807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20123617 [ RunTime:0.002570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53577905 LIMIT 5 [ RunTime:0.001185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53577905 ORDER BY `minOrder` ASC [ RunTime:0.003538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53577905 ORDER BY `unit` DESC [ RunTime:0.008455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53577905 LIMIT 2 [ RunTime:0.010987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53577905 ORDER BY `minOrder` ASC [ RunTime:0.001761s ]
select * from pdf where partno='19140010402' and brandshort='HARTING' limit 1 [ RunTime:0.000286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19140010402' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.000327s ]
SELECT `id` FROM `stock` WHERE `id` <> 53577905 AND `partno` = '19140010402' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.000765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20123384 [ RunTime:0.006708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49538101 LIMIT 5 [ RunTime:0.010272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49538101 ORDER BY `minOrder` ASC [ RunTime:0.006087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49538101 ORDER BY `unit` DESC [ RunTime:0.001948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49538101 LIMIT 2 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49538101 ORDER BY `minOrder` ASC [ RunTime:0.000764s ]
select * from pdf where partno='1914' and brandshort='Davies Molding, LLC' limit 1 [ RunTime:0.000668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1914' OR `brand` LIKE 'Davies Molding, LLC%' ) ) LIMIT 1 [ RunTime:0.000359s ]
SELECT `id` FROM `stock` WHERE `id` <> 49538101 AND `partno` = '1914' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%davies molding, llc%' ) [ RunTime:0.003392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12061986 [ RunTime:0.007326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36731530 LIMIT 5 [ RunTime:0.009248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36731530 ORDER BY `minOrder` ASC [ RunTime:0.002685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36731530 ORDER BY `unit` DESC [ RunTime:0.001687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36731530 LIMIT 2 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36731530 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
select * from pdf where partno='1914' and brandshort='Davies Molding, LLC' limit 1 [ RunTime:0.000402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1914' OR `brand` LIKE 'Davies Molding, LLC%' ) ) LIMIT 1 [ RunTime:0.000272s ]
SELECT `id` FROM `stock` WHERE `id` <> 36731530 AND `partno` = '1914' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%davies molding, llc%' ) [ RunTime:0.003533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12061986 [ RunTime:0.001574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51458993 LIMIT 5 [ RunTime:0.004455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51458993 ORDER BY `minOrder` ASC [ RunTime:0.001981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51458993 ORDER BY `unit` DESC [ RunTime:0.005881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51458993 LIMIT 2 [ RunTime:0.002505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51458993 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
select * from pdf where partno='1914N' and brandshort='Electroswitch' limit 1 [ RunTime:0.002348s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1914N' OR `brand` LIKE 'Electroswitch%' ) ) LIMIT 1 [ RunTime:0.000663s ]
SELECT `id` FROM `stock` WHERE `id` <> 51458993 AND `partno` = '1914N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%electroswitch%' ) [ RunTime:0.002979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17289969 [ RunTime:0.004673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53739492 LIMIT 5 [ RunTime:0.002491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53739492 ORDER BY `minOrder` ASC [ RunTime:0.002589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53739492 ORDER BY `unit` DESC [ RunTime:0.005716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53739492 LIMIT 2 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53739492 ORDER BY `minOrder` ASC [ RunTime:0.004998s ]
select * from pdf where partno='1914640000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1914640000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002191s ]
SELECT `id` FROM `stock` WHERE `id` <> 53739492 AND `partno` = '1914640000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12544251 [ RunTime:0.000522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53577907 LIMIT 5 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53577907 ORDER BY `minOrder` ASC [ RunTime:0.007565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53577907 ORDER BY `unit` DESC [ RunTime:0.001222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53577907 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53577907 ORDER BY `minOrder` ASC [ RunTime:0.002770s ]
select * from pdf where partno='19140020402' and brandshort='HARTING' limit 1 [ RunTime:0.008335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19140020402' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004371s ]
SELECT `id` FROM `stock` WHERE `id` <> 53577907 AND `partno` = '19140020402' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.012798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13108243 [ RunTime:0.009298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53741966 LIMIT 5 [ RunTime:0.006184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741966 ORDER BY `minOrder` ASC [ RunTime:0.004823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53741966 ORDER BY `unit` DESC [ RunTime:0.004290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53741966 LIMIT 2 [ RunTime:0.004473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741966 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
select * from pdf where partno='1914020000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1914020000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.017623s ]
SELECT `id` FROM `stock` WHERE `id` <> 53741966 AND `partno` = '1914020000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11442796 [ RunTime:0.004020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53578515 LIMIT 5 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53578515 ORDER BY `minOrder` ASC [ RunTime:0.018240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53578515 ORDER BY `unit` DESC [ RunTime:0.006661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53578515 LIMIT 2 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53578515 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='19140020400' and brandshort='HARTING' limit 1 [ RunTime:0.000712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19140020400' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.006595s ]
SELECT `id` FROM `stock` WHERE `id` <> 53578515 AND `partno` = '19140020400' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15561232 [ RunTime:0.000516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53742025 LIMIT 5 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53742025 ORDER BY `minOrder` ASC [ RunTime:0.009034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53742025 ORDER BY `unit` DESC [ RunTime:0.006809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53742025 LIMIT 2 [ RunTime:0.019516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53742025 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
select * from pdf where partno='1914040000' and brandshort='Weidmüller' limit 1 [ RunTime:0.012120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1914040000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010462s ]
SELECT `id` FROM `stock` WHERE `id` <> 53742025 AND `partno` = '1914040000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11442813 [ RunTime:0.016825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53663338 LIMIT 5 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53663338 ORDER BY `minOrder` ASC [ RunTime:0.009909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53663338 ORDER BY `unit` DESC [ RunTime:0.000313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53663338 LIMIT 2 [ RunTime:0.003021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53663338 ORDER BY `minOrder` ASC [ RunTime:0.005110s ]
select * from pdf where partno='1914218' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1914218' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000333s ]
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 '1914%' OR `brand` LIKE '1914%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006549s ]
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 '1914%' OR `brand` LIKE '1914%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009149s ]
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 '1914%' OR `brand` LIKE '1914%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002229s ]
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 '1914%' OR `brand` LIKE '1914%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007965s ]
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 '1914%' OR `brand` LIKE '1914%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002010s ]
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 '1914%' OR `brand` LIKE '1914%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000874s ]
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 '1914%' OR `brand` LIKE '1914%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004565s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1914%' OR `brand` LIKE '1914%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011879s ]