SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001929s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 147708 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 147708 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001981,921088,155397,484305,85413,407172,529385,73467,345500,80990,763639,429018,882393,758816,943603,628418,284238,781361,222950,302106,40542,96147,841332,61744,746670,862303,58460,742373,509453,252689,522672,72856,121742,395242,157017,657411,322029,312550,693932,757205,3004,363367,10929,145916,954508,338395,561043,872794,548383,282488,954603,360151,557564,854342,77687,67188,992306,1024034,1031796,91570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 147708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 147708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]