SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311491 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311491 [ RunTime:0.002720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50591,623246,127199,459649,545882,67554,419159,1048483,59702,875982,991290,509815,1009964,948305,407484,247472,365270,445155,401577,1029257,321334,976362,517348,384299,523199,178073,807369,410806,384027,105260,109093,165054,503771,964544,345254,791808,587818,983543,81899,571117,489719,278165,1001412,365596,916191,440446,406310,619046,39307,646537,863611,865713,881264,893245,613457,497254,439791,497840,306847,778655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]