SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002046s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292943 LIMIT 1 [ RunTime:0.001455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292943 [ RunTime:0.004108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321412,578025,746852,402041,967773,304083,66453,582546,11165,233026,781636,743823,167018,172291,649617,888142,39297,866968,291680,783509,533864,335796,909603,1045011,32520,249407,892059,648890,619285,147904,948127,45337,599058,863438,761731,355477,196055,704074,8180,141946,912474,300527,596707,672386,210409,36539,167006,788151,173472,391390,546272,296531,270021,153210,112553,651310,34489,657397,1020070,57948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]