SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502263 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502263 [ RunTime:0.002141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946163,833983,791202,311925,362361,289638,942024,436020,48479,481184,731947,536843,271060,979099,531070,911472,323975,970321,642163,1014088,508633,748041,555882,138424,167385,823033,533477,948226,575748,929107,73007,291190,713857,330743,314338,857275,576576,633438,762716,728648,315375,861100,879685,776176,377718,320382,624941,251512,291922,502071,250717,1039323,976392,1014703,197188,933103,139914,608606,882715,445560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]