SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402736 LIMIT 1 [ RunTime:0.003011s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402736 [ RunTime:0.002411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443605,420686,170609,952254,445081,457466,44528,789954,302702,1020455,336624,34971,352570,985791,533302,43379,544911,101193,483843,285402,228305,727606,680404,524703,957994,771619,764913,89811,852765,248371,337395,209117,226094,261859,113024,780681,43066,378376,503442,1004978,824642,616299,667988,337908,624961,444305,648759,567424,813092,903065,117780,31158,59153,269700,770858,952647,778615,706876,352757,919643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402736 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402736 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]