SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007222 LIMIT 1 [ RunTime:0.000276s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007222 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003300,1019145,255478,915344,791677,673348,35598,1047072,381082,462151,630757,708206,275218,359085,729019,259270,434321,215101,102255,633409,617816,293294,491830,306854,177551,663641,249433,795794,459272,288972,990915,1013370,695435,373008,705342,633678,749794,36656,681674,952168,574749,330831,560795,33726,817312,995611,52240,611999,797350,1021406,351397,170604,158298,22003,574260,128551,609633,573268,987071,422617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001288s ]