SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54888 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54888 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536893,1048834,214229,589051,300242,1012586,603498,333898,784056,346022,908373,966192,574652,25264,742737,383478,299747,391833,408286,850116,69805,495833,630734,511352,83564,356438,791325,841865,921261,64352,828624,956531,456038,413471,263766,447607,716653,817074,971675,202240,801581,434532,543473,265267,531342,1041603,276899,228872,889027,989010,890313,362967,179749,137902,851183,372249,120845,133048,215085,151169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000908s ]