SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498201 LIMIT 1 [ RunTime:0.000850s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498201 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698948,845756,494436,1041322,172994,611787,634122,41671,262910,1007500,737433,436067,841836,931911,492731,305633,300313,488884,731536,962745,282046,358743,686857,752764,441475,593942,290836,770027,428464,649679,723940,133628,633646,539540,1033864,123845,674595,781568,307211,859377,350317,576166,1032992,224574,652719,927248,125946,403520,58704,96633,261872,979332,653283,804242,150304,755349,463424,474744,362945,134068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]