SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542011 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542011 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872249,233205,307415,989462,762158,75270,432207,327392,844459,460585,68046,395025,358490,613894,966207,421561,418406,210830,680174,460126,140541,9675,14261,597888,532012,514765,673386,887306,396930,389375,23490,994637,640555,712711,905231,447584,644398,805912,565535,160571,625981,522794,523171,39675,901873,117822,162400,161209,230151,623830,409807,705057,337985,640920,806814,987,161831,386994,876761,67497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]