SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438520 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438520 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955470,175975,262010,680554,1036880,7103,456373,614349,83615,493031,872596,63861,990724,622221,860022,542790,384699,446234,18649,322949,952091,393562,817596,602849,77069,556231,365262,952499,397388,170939,81270,902934,696691,517184,891633,203729,51782,473400,677069,28427,404602,730787,227673,69319,49873,470561,686160,1045931,698025,177863,518009,327256,497465,908082,20308,365002,365884,939914,49584,604363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001319s ]