SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111053 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111053 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753354,915704,121138,172372,533076,767722,681531,234647,30411,288925,143703,46752,10529,682820,933531,36576,497402,439414,187280,109382,446799,324532,490614,672983,894763,138047,991375,434238,517674,998219,597671,712794,296357,875570,602866,914914,564131,241260,990288,23936,280516,566734,798693,256003,491050,304487,833984,557870,756822,618283,1017637,80295,724655,942426,314640,757335,525724,31893,969410,51992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]