SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481110 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481110 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148227,270742,854246,521855,169282,654716,168267,532622,980617,879221,1020636,165399,336079,25001,435028,400798,676081,284905,420908,873653,615125,978740,95280,7865,652882,654392,37703,1038596,577879,618530,931824,70122,749780,7028,21210,364154,81680,500725,883984,326984,412088,936557,478743,337905,782721,151956,612803,456289,51771,390944,729919,464268,579978,734423,449980,369171,304757,219662,390861,680322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]