SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028515 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028515 [ RunTime:0.002300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118906,257447,328578,249023,624268,688456,886578,36783,225589,672201,392274,831281,274371,506779,592345,536625,546450,685034,798997,944391,853563,187583,957881,547271,424347,935421,560977,866547,929038,408897,874024,179973,772632,166007,909193,484540,1044845,199148,657124,213593,200075,325719,734264,29616,866700,705867,868752,217289,430347,659109,962452,118873,269539,555636,182780,849559,932993,774827,681704,27072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000763s ]