SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014087 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014087 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (679726,963968,110353,300421,850692,614783,830384,17590,1032919,102576,413804,63148,460215,146444,967013,670003,919603,306265,538709,777177,619490,890104,385666,78893,122054,310228,443426,482244,194163,30025,193763,887289,1004611,308484,500917,446861,20737,549793,819659,96366,793470,176925,533222,245549,276018,11834,1041629,308992,174955,637978,563525,180308,655084,18977,251811,296138,666679,712420,435656,813972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]