SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529405 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529405 [ RunTime:0.003315s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048880,494242,964824,302093,200818,229391,300142,339960,680284,1044157,366735,913212,341301,628102,614207,1008943,15803,694482,612869,281690,1041935,279593,820857,862942,469468,637863,37284,121916,325923,757500,750799,375433,1038384,930637,471628,423627,745688,130601,895736,890368,1000866,841031,587183,365140,355029,398945,864964,348284,127241,929627,146913,299009,746168,828758,507863,591754,377929,1480,220990,436229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]