SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28401 LIMIT 1 [ RunTime:0.001715s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28401 [ RunTime:0.002461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629852,615951,434103,1019935,367009,598958,669080,271830,560002,257212,258715,997239,869999,353383,788443,944989,848123,988867,928072,690665,476771,179404,358571,243710,689741,252928,60495,123502,181711,510772,622926,124873,253275,52199,400780,367432,122653,509454,102652,779582,1034958,746987,565045,910490,655882,43206,611683,306018,961513,160226,663510,556456,846256,159259,465803,754440,172594,199591,249800,453940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]