SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345992 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345992 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417428,430803,203396,356362,793477,251714,614935,722384,842780,955399,883826,830945,971029,473758,197662,157556,26206,170317,902083,522097,441728,806944,410024,875367,422005,549637,369466,671417,330019,954977,474643,133240,330399,328879,56752,1027656,632947,979556,697643,29580,813150,292335,308917,961361,147839,780515,357077,239870,775456,148579,679088,610892,9912,103455,345325,393399,129845,100974,36219,1002796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]