SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010910 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010910 [ RunTime:0.003219s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150806,557765,1024197,745286,845403,31551,873954,581540,751762,203136,945341,441961,839015,740917,915376,172025,452735,825723,948620,1012265,459149,859598,177690,965165,673302,819664,44275,657090,239632,518120,930941,38240,403624,315872,840574,201068,839937,429676,697596,371650,774177,591537,877977,197426,675705,43123,41455,222421,953301,524120,987618,969249,477726,837660,536768,492477,272398,98426,338200,970966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]