SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 274151 LIMIT 1 [ RunTime:0.002134s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 274151 [ RunTime:0.004321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80110,805358,101596,494389,605100,947872,866009,332174,394198,494438,693937,249054,921040,943090,925066,491454,274111,350891,389718,832504,870572,733853,49004,208694,272276,643591,1015241,293225,401980,419170,278147,337996,438153,55388,221487,451256,321161,289669,26507,290510,617170,661741,540307,631710,593217,235513,247878,1022934,322170,385196,392091,672762,976197,514344,938797,28025,405873,62483,1044084,155776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 274151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 274151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002127s ]