SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29213 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29213 [ RunTime:0.003197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402073,639359,676152,17609,194657,632622,177291,370179,274970,853220,964455,28958,898482,574700,342406,110752,661731,865348,1036063,180480,431117,90073,230860,547875,869359,381632,364330,416501,878990,1010648,894316,681191,361035,1027071,327510,825911,919169,817589,217510,126405,904669,232779,757450,814756,611220,859265,976280,171042,570237,366347,898394,353422,178896,993065,718402,477430,590144,572958,254815,1036044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]