SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510748 LIMIT 1 [ RunTime:0.002141s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510748 [ RunTime:0.003542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943452,518205,629336,384609,1041519,1008748,52467,214881,526820,151874,127790,243624,439487,542611,478869,312921,19704,861569,953568,1031835,638379,428406,813809,22345,841253,322468,38273,371399,746490,560618,594191,512408,776306,42104,137505,818173,38770,26868,337898,26652,973890,7489,566012,246085,154984,253553,516825,747137,860071,58108,582914,25283,396431,46618,1019659,758101,138948,713037,164870,45430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]