SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392328 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392328 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251624,598082,682348,522587,859474,270628,940653,817388,408896,650520,146534,813349,555971,939848,96332,238224,722688,42508,624344,648386,244409,355410,247272,1012134,346686,304298,1029039,177051,840708,555366,110227,981558,375281,485050,33630,113262,707760,478364,445763,106931,75420,1040445,57216,346023,366008,1001930,50934,712441,1033524,753470,45824,381458,749319,466662,520868,893886,838320,620989,92169,1001297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]