SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016284 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016284 [ RunTime:0.002522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20240,540696,749351,506098,673538,320968,590214,267152,901693,317823,376323,725794,852712,330808,1044861,438291,429949,311185,806470,563854,448646,272517,304371,133661,737609,93764,409018,596979,380833,168537,358052,590298,146844,452308,1020567,243131,190420,278131,733614,465237,77701,426387,602198,987173,59947,116935,805822,97943,1046033,13646,694698,420782,962551,587471,1047450,61289,33174,1008153,657620,563355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]