SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475051 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475051 [ RunTime:0.004026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (908416,1034031,11499,1036555,934678,798055,236566,41781,862983,383451,907042,708063,717452,691033,398175,630248,541504,297030,615712,249670,211329,756044,20782,923983,281314,952290,84212,1030122,231709,959139,122699,525852,372713,811534,802952,632712,742155,743760,635852,300072,901261,257628,1045658,434469,570166,994851,380498,1013525,543249,474155,169583,665924,1047576,574813,602629,382858,202622,1022048,380644,795887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]