SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416289 LIMIT 1 [ RunTime:0.001588s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416289 [ RunTime:0.002030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349620,650101,637022,752727,954556,188996,353723,472835,434988,1013066,153136,914326,76200,818556,569832,1037504,306516,693566,413847,909096,701812,293946,774298,484891,994433,221647,913854,345689,417694,986516,711371,373175,652619,9014,242738,651018,142266,267386,275528,543945,1037801,700683,880344,58434,974444,295998,751437,353954,289847,886853,755292,90245,799261,615899,154760,510412,366914,17201,42865,917605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]