SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42413 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42413 [ RunTime:0.003904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609129,840932,794630,103749,86455,509093,667336,525890,416731,635019,336737,910107,452411,138987,942292,982961,1046511,100756,252686,205417,371446,719441,1037989,176129,436391,619744,919794,920729,84031,370677,742618,662973,972858,847586,736767,800207,452675,637573,343903,387769,750139,125128,806972,282880,901514,179120,34601,316149,379418,559594,510410,54364,946965,421362,499346,182007,909419,275343,702557,496685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000744s ]