SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426091 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426091 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299496,650442,525698,69400,237249,92719,117926,649772,533089,741693,496831,1040868,480262,663540,266490,449877,180302,318633,669482,204603,904251,493751,669592,28794,67880,477730,676442,689706,448884,675381,110496,312971,62954,30728,702033,607342,835296,830276,332984,123518,346049,772618,1040423,762782,296099,125030,97942,750439,566360,700609,787666,265325,486864,1011521,681891,72075,771171,553624,574439,771907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]