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` = 40610 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40610 [ RunTime:0.002314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675364,161205,414381,907858,1032229,421127,297591,801261,872927,842399,580985,1032060,119979,549871,562471,399880,184564,436132,55102,255615,236329,326206,486379,167988,416600,657505,192325,706032,503403,171479,695810,176830,836640,516726,695047,105040,275834,213529,510875,478518,747950,374289,844663,846111,50021,122359,547567,301435,916003,493060,345892,654558,527827,525404,897673,814587,529576,398646,263627,927999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]