SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54889 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54889 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97488,891631,404859,314423,62784,105136,435978,169856,81778,527096,163363,2391,668480,893668,433205,933297,466687,921725,546246,845144,307693,893093,652010,141852,811281,990171,604802,1047448,401776,552995,557291,978259,959484,910783,393405,68567,377272,74142,535185,344584,789991,1008466,667728,350587,608655,714362,678849,351363,777267,341191,948995,938141,688207,651650,418770,205257,433631,358886,447377,70972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54889 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54889 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]