SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267113 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267113 [ RunTime:0.002295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660003,847968,816428,83029,576886,58440,27783,352151,362620,542217,96239,804007,607211,633567,673000,325577,384007,468260,915831,304489,194221,826607,662871,743495,641273,241881,523348,1022557,703636,638172,74735,1005817,934970,397050,616477,270988,196313,953062,181153,161750,894900,651828,60302,879634,319143,514214,1037571,173244,772900,162441,904983,375904,536234,1046961,568179,991040,582225,690193,249586,1030933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]