SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029083 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029083 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699755,82126,279331,312692,1048414,1036151,775215,783807,849203,668193,622324,28636,584054,659568,420626,274983,5244,941763,1007305,75049,672113,398290,706807,7252,1019700,283284,508449,3941,1043003,617673,167086,346960,533249,872809,498671,539037,427672,56361,880622,456927,71187,228845,940342,976423,846138,975012,1014717,89322,41559,986085,427959,26505,799069,56201,458020,177590,796772,304388,687514,844458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]