SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489210 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489210 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493806,97844,855994,697503,335622,106666,689043,619001,851846,338788,62040,170480,374405,2005,184342,1010775,578856,454548,569690,744818,1001676,540110,685399,322994,985873,1013461,84091,503706,204745,438422,889710,292137,834288,517152,918949,885851,289274,875559,79329,3006,185643,616993,405074,401016,815005,146006,809923,6220,615579,924902,385569,942986,511735,281282,923913,110349,366785,85629,384848,531776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]