SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342930 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342930 [ RunTime:0.003335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (950338,1019899,1023299,630625,621594,706659,197726,179213,798602,529670,538640,799521,556060,920467,762536,708326,1016726,740939,598139,988292,645323,842227,415112,298140,181834,577514,70998,994790,254298,711788,595784,203050,857418,106718,705420,769404,1009293,488944,575504,73859,74990,1026700,539430,920060,855142,296522,588481,60973,652374,862012,837279,598994,245150,610012,686398,896742,384330,354177,23323,35549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]