SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401304 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401304 [ RunTime:0.002257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3749,719187,633322,524857,20472,767384,642667,166296,879207,384153,255609,185880,56271,8260,425261,1039697,918349,667341,81386,770102,105262,831080,945558,412810,505020,837236,1019162,163756,1011069,460146,111404,870377,427041,1016840,868288,151496,33250,1024443,537082,28752,379285,218556,587743,246749,357952,496749,737641,819603,1038542,1031697,241644,732075,891064,375070,802311,578878,28184,117811,926114,548286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000863s ]