SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003642s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475691 LIMIT 1 [ RunTime:0.003681s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475691 [ RunTime:0.004650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26814,410353,738230,947440,637283,584891,831579,702408,793714,58936,87305,284989,106977,770848,677313,776910,286970,190620,287424,839778,780071,650371,6909,336184,259072,218792,1001037,910125,55224,737221,756178,635092,1042825,431458,65031,423441,529394,862351,21148,459795,597902,716392,148155,35715,965363,817524,302387,492075,848918,593622,546253,350641,637874,367614,514117,295528,488302,826360,335908,842865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]