SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012829 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012829 [ RunTime:0.002408s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820388,497904,69250,150734,876442,610290,854186,663714,740249,442447,544842,41791,711665,384666,719061,48983,305515,718258,133698,936633,51513,32691,669783,1002444,9319,130733,681093,198736,1000734,350552,451496,494771,629263,373451,999062,216605,140146,851153,57363,736434,552446,599842,252815,481556,872721,820758,917724,119041,911697,52131,123000,608081,895647,75195,770734,386818,452162,519355,1016360,322590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]