SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98616 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98616 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108987,390032,825301,195082,819755,529549,1003671,220196,1026234,1005240,777708,515948,837069,746287,156815,465138,661030,329170,469271,7726,822491,836122,117738,994200,944218,515345,908263,399151,498958,1025655,454216,105386,441475,896238,68875,762287,524817,302570,597958,100624,418907,110224,207305,190774,757569,42912,148367,852990,676044,83067,309542,470391,590494,23723,911704,299281,21634,347701,939468,772352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]