SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539266 LIMIT 1 [ RunTime:0.000565s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539266 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562272,890974,373860,237486,234667,963801,1045698,413793,997737,112820,54083,691082,465940,488169,614104,1014752,292031,421299,676564,862606,514981,448031,408561,180633,693704,788829,746726,842008,80908,677656,709377,85213,837374,133857,837683,568807,158798,5261,462836,812907,579752,848386,346637,617327,341437,687192,67183,545775,104728,1036024,86963,706700,888790,848750,415853,534472,141387,471714,93156,426430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001969s ]