SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439842 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439842 [ RunTime:0.003266s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82196,115285,462954,1001110,913097,613517,709986,999524,1023991,589164,911426,27192,18957,216374,41143,480282,195473,117607,788409,143393,1003477,788995,542216,585018,306093,794061,148665,627240,269211,458228,825272,990724,280107,963975,799833,653031,740151,3696,892880,463212,52218,28523,416139,201721,927397,24920,136385,280643,1004352,613039,983832,251829,573729,945415,490198,224939,808090,376922,685624,111711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001491s ]