SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520868 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520868 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388765,22850,665912,518983,1034866,900441,448254,291033,416830,972047,377386,810986,1022492,204405,110509,787101,766471,144948,383551,721345,124449,745159,985569,859045,1041807,379805,797162,705867,79276,890263,946872,525161,734200,35812,709090,566147,668726,578036,154397,17752,127812,847109,288589,423571,844678,763793,412548,787015,217537,87238,784640,386174,329017,320465,311005,107430,163191,444989,159769,692544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520868 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520868 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001173s ]