SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5220 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5220 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282854,1012972,470009,451625,807555,940307,862408,316753,121587,266583,416429,361055,570090,179430,941079,486465,699793,236007,857090,791502,3788,122541,978862,456199,283454,23129,884286,713214,652166,405575,291321,465296,1044146,771649,198259,360855,438673,821997,40674,763668,667831,1034140,489054,658176,352060,437871,416634,803518,879197,733121,934329,640215,864744,895890,649628,890582,802844,380526,215131,411613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]