SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413907 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413907 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644111,673324,755625,532584,341778,485874,524043,649463,995335,309305,797031,945185,460225,722899,448840,382343,428476,998427,441476,883673,408774,973087,707387,965748,1024662,869060,567801,422576,20006,29730,354272,251805,779069,364137,243111,834608,937646,131901,153520,525185,305420,327800,762901,469612,480775,158038,817631,953642,298452,513067,436890,793764,852757,251868,1045228,216465,670928,457920,839065,353363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]