SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450481 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450481 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485003,269684,696460,173337,386219,48782,373704,352899,517300,1000030,926193,216547,752585,648081,126371,262090,97675,838423,1045295,987633,655681,461786,1043292,990164,936869,613312,693487,472524,245719,124113,972052,302521,165754,156303,1016109,38320,302892,993892,1038632,69135,768534,395508,651594,456858,978868,123849,790188,429097,650699,799740,572074,237081,912909,352355,846825,475356,1036461,481520,738060,1032137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]