SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491307 LIMIT 1 [ RunTime:0.001208s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491307 [ RunTime:0.008259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008077,683221,433019,993779,718328,525341,260350,218344,543226,319873,954046,1035595,906748,278306,486931,499222,879560,331161,153422,697235,133846,100801,309617,56974,766863,994784,634544,885332,661370,866384,754704,631353,835314,310473,379139,372138,665042,806487,485337,991281,551564,327703,558338,22767,672984,897886,3655,1012948,2624,996578,405310,989494,682852,684439,139017,123659,38783,135410,62304,997036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]