SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380300 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380300 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313014,511794,693061,424761,139195,1010988,841815,493476,515747,952045,851387,590380,803383,455261,323376,153936,240751,591341,316328,62483,825218,10383,267860,1013755,159112,536486,201603,1036126,626152,145750,982130,719963,348796,1041720,255078,19102,780318,35816,1005958,493367,243825,926586,285194,389062,82098,492468,789305,409146,682699,551926,171951,490483,722012,966536,511624,583060,396490,140995,609514,827438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]