SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420035 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420035 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362861,923628,297126,920100,246529,602401,762223,763173,956615,151441,177170,531229,825050,10112,332714,894287,529881,100724,467088,1010635,476204,451147,164432,376145,565725,104456,198280,810106,673679,1011461,105790,436103,80399,678543,204866,884563,10740,735336,951951,126670,740698,814754,583062,87339,967284,919250,442030,729004,876565,388112,567611,749345,525920,165541,873164,239709,968842,464343,36285,353657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]