SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 722583 LIMIT 1 [ RunTime:0.000601s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 722583 [ RunTime:0.002183s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771986,200044,453506,847806,447669,141646,155201,21599,791005,254324,969742,955423,489695,948207,125988,603038,282411,163999,560603,703043,118856,592580,443077,507837,585703,545202,725252,281794,340857,1043384,750906,579548,470350,379469,775178,100912,405993,765038,655505,360346,84395,168513,896507,454592,959839,474899,451170,991548,691773,1004416,16217,906731,576948,532038,815861,706112,511371,523311,914071,232317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 722583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 722583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]