SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39819 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39819 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436815,774829,684675,157173,135022,60275,923127,668605,547471,587284,960537,416303,895491,1048623,921036,408074,257105,1021317,403109,222071,594081,568217,777203,869945,76904,651123,688858,200401,815314,200793,27834,919613,303097,787823,860665,197095,247645,496476,112541,886945,1012799,464217,36231,534939,86807,968713,654969,123603,126938,456335,356584,355558,608123,609560,65146,412963,534994,538753,349799,1041734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]