SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104473 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104473 [ RunTime:0.004784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946276,641705,491352,509140,444766,885982,457600,801261,613075,630170,278850,397321,269854,776263,95185,502862,816630,666509,385597,96359,1020786,356150,38165,1043490,879696,792716,353966,690681,57524,110177,943624,372260,911635,971464,36737,321952,757177,250730,902706,429665,680606,970696,406026,485075,846905,166850,561044,696313,881800,133363,190130,714313,531561,814083,172552,463722,373512,798865,572246,971777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]