SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030134 LIMIT 1 [ RunTime:0.004537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030134 [ RunTime:0.003373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174956,333619,91901,827880,495324,296604,102396,129900,517491,96093,1045106,667613,198341,176529,312464,667372,452756,602936,395756,123606,540402,481977,364432,209720,697354,787947,439719,88719,333875,851136,276025,435461,944632,563535,918921,802822,109599,757877,127673,279969,501869,185517,241836,956723,888991,408295,695671,214748,526586,766326,806929,575702,1033737,620053,60496,992945,661425,565942,56334,568358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]