SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484595 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484595 [ RunTime:0.003410s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60122,73237,108280,19426,740646,450626,488282,71086,49626,762530,422524,784394,781293,160824,249286,731636,269686,397916,662309,548478,712200,222618,347990,484565,932896,1003421,446686,936182,344635,1026165,507948,159255,653731,252900,671755,1017967,403993,661863,308969,683634,287041,401886,359270,452874,659502,330195,747566,665386,276653,960246,119577,723782,732782,948913,362856,87175,867829,674918,780735,894987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484595 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484595 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]