SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466083 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466083 [ RunTime:0.002438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128587,487695,116912,741773,55699,458275,549117,771211,587246,568654,275765,933163,409906,708274,478623,769587,388541,990694,138129,64357,415650,608127,386567,604683,625781,305990,653030,139012,563876,338289,754090,725800,68398,98015,604745,641631,39288,158843,81222,37603,772954,113714,136434,485561,641134,760541,743540,170345,516658,229988,1028078,839531,201712,130162,14960,55526,677622,712108,265503,766512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000898s ]