SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43841 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43841 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166664,30603,250786,863483,380577,302639,215408,506746,452255,635865,202702,198307,376143,919209,743330,964813,448636,862574,904287,592259,1046421,347651,100828,634498,156534,580262,534381,1044463,288835,991462,1030309,894038,851339,540833,826773,1006458,626770,448461,260069,184717,192298,272776,422425,560678,794195,371431,208048,921626,218538,755382,220055,148920,813231,916870,20384,675374,139550,1011565,392657,711751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]