SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392014 LIMIT 1 [ RunTime:0.003022s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392014 [ RunTime:0.002345s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123288,118817,226252,104848,889705,292072,161244,326456,592628,923558,574201,951562,396093,906639,231342,704668,429924,835265,144546,330907,394014,393810,357909,735442,45566,731193,293445,625260,836431,799538,23437,154057,692376,422491,229527,1043344,66620,682510,64475,169737,876186,722418,985818,884285,233235,535816,180767,70582,326195,735980,547419,352149,67341,345771,659428,578047,383663,1019926,104734,571843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001295s ]