SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540839 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540839 [ RunTime:0.001535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697295,34392,59115,392992,941197,821540,847638,993758,159804,280482,904699,34805,132041,712570,566073,268236,764010,196243,296973,644568,765030,273712,83048,825709,997371,466983,795726,1014771,865109,840794,862341,830569,45060,202358,440037,914677,484081,558634,535724,658225,749231,739362,1008489,986202,1032962,1013027,35207,917732,614984,605761,69830,478915,950336,40532,341477,404533,533657,203877,195967,335051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]