SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001996s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31796 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31796 [ RunTime:0.002600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245242,24157,633295,30696,691716,570438,676317,546002,524703,847876,374720,689656,967120,316176,790668,354540,73644,349568,322478,633740,838394,681770,833044,38146,454304,653093,490246,855913,381387,560576,345897,662968,704308,510352,911832,38639,224102,235306,376297,162629,1040170,536249,759210,584036,696890,13491,100600,725347,748060,879833,557840,490284,205799,92,648810,613600,800306,562500,806515,786509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002221s ]