SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105716 LIMIT 1 [ RunTime:0.000273s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105716 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705547,915804,1019848,149579,91082,671315,583908,655710,417816,281786,51483,415268,1031889,846461,642811,843539,832362,306129,382383,732332,870921,837655,371352,391915,422247,187528,219956,412951,144359,528346,100527,733161,408663,659470,741428,549385,424560,415133,456989,876131,103405,578385,10027,109411,855255,115352,665121,971358,522511,830109,929673,241170,901063,626082,1045350,888887,210863,418200,334455,29040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000745s ]