SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422001 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422001 [ RunTime:0.003567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479351,829014,408119,567463,314138,217233,53111,166019,480090,1018376,667104,438645,247527,508932,783294,561632,229294,630833,739841,933806,962557,358899,763724,589753,436586,653281,199070,559036,871919,311843,73636,711506,603594,959508,904259,868690,480999,343021,445513,75356,824882,997475,961429,317915,278522,765085,902974,576482,758564,549102,718190,478931,793798,314818,857649,672409,733380,400582,848577,334836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]