SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 618911 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 618911 [ RunTime:0.003515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604634,700796,312413,947936,985400,656471,260360,851016,398413,278220,626067,17737,246957,791143,668538,216106,568454,487674,236360,157871,938516,275368,241098,573429,159498,87323,282497,374242,253180,690581,545567,279226,331745,583421,313122,830196,722781,128697,808908,152788,276349,780030,1028818,487956,389916,338000,272739,177283,370454,1014038,972133,648151,429004,506438,155814,637342,1038290,940030,847757,262352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 618911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 618911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]