SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001828s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419100 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419100 [ RunTime:0.002117s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779474,873319,3359,244626,534600,155681,169192,709784,518322,74215,408274,763565,546030,464757,109282,211547,125535,529136,385824,7842,695359,726719,561792,391795,241413,869838,495866,22504,94993,312667,302993,334448,779574,121053,762889,874484,506920,274084,995030,384110,679033,340765,230614,856784,987686,426310,718923,425139,883150,728294,524143,650466,60231,739479,239842,1022788,608994,29250,300367,275998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]