SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044231 LIMIT 1 [ RunTime:0.001305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044231 [ RunTime:0.004573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492595,514399,614342,877307,805146,816884,941014,752427,78138,381603,76772,54290,818524,544222,41656,373622,224105,472454,912396,479816,359335,501258,900805,415360,844162,994999,906492,36546,428684,60888,296313,901287,338065,110032,973484,702614,553061,959965,717877,574570,567380,700120,389745,381693,506377,149726,660540,717826,39500,543109,274331,865789,546540,501617,660698,436371,499135,951884,7060,42361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.022860s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001652s ]