SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35864 LIMIT 1 [ RunTime:0.000989s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35864 [ RunTime:0.003340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180529,108778,610912,495925,247801,590628,334576,409874,1045743,99985,705146,761800,573766,777051,454936,1023117,494727,853674,687933,797249,473343,520846,506561,1019431,649481,446190,1008448,184827,638368,783482,667609,713433,594664,254424,201079,840097,83730,980712,640993,736554,333567,315200,247735,37186,410369,128415,552974,978744,636680,232701,430759,243859,51604,396203,732237,818268,844183,951747,361574,922279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]