SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100039 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100039 [ RunTime:0.002759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043691,422902,806582,1045690,124099,925219,822437,587340,5141,1026483,592211,1045121,852956,135718,335008,755233,503661,222842,453477,680092,914504,880339,720025,781733,852447,127085,599476,170785,758310,1027500,429076,456355,559298,1024434,206142,549081,736633,995086,1042135,856332,837865,398984,83943,35592,53035,360955,67323,223630,510635,863521,799952,418214,551216,872255,789380,131549,465787,263326,266962,136813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]