SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502511 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502511 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17837,205987,179978,544032,819261,388661,202199,118531,148894,120866,202032,548610,248256,385371,176610,783650,94817,43295,822306,76902,331565,197814,267299,888877,597697,729039,100615,31771,540763,552086,257569,260387,447878,665644,332104,985703,707065,734173,308092,406378,359389,844897,898652,472410,290362,932446,268288,229559,1015925,704202,508044,219087,205748,779084,825478,403030,660804,734525,985091,918011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]