SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028564 LIMIT 1 [ RunTime:0.001636s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028564 [ RunTime:0.002397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576851,880056,326262,699499,956379,838352,411632,17157,79784,508776,947202,723590,521408,825517,437313,325975,531595,512906,758334,929597,285190,818812,596628,179787,314598,800936,351686,921103,252890,654427,731519,822912,85763,826231,598187,637024,361876,471145,758497,97545,208770,704574,128109,800078,54885,696167,988526,478224,743235,858000,422858,827482,793242,967766,28727,764850,1032508,284524,601840,264697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001472s ]