SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039601 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039601 [ RunTime:0.002136s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201698,653170,88194,35071,758582,880471,338752,627541,944823,866413,110948,337451,51809,623251,724528,999743,967973,578084,206201,942026,674004,535620,984367,748154,560701,964656,350583,1025460,75814,94740,951930,138092,1040223,334670,847600,662696,496343,724763,351204,564278,967405,950360,960739,421668,722648,768529,1940,315292,907794,790681,754475,232471,824102,67733,371853,257753,991178,413781,804205,577246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]