SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005042s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341481 LIMIT 1 [ RunTime:0.003346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341481 [ RunTime:0.007326s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048256,736401,170216,465571,639216,992511,135508,1013654,8187,280517,19903,272061,8510,865362,499259,86129,128790,831598,484852,587600,29862,546585,697312,339002,478804,56826,587669,406424,791059,238144,488800,451811,998435,716690,823334,371021,821273,56989,66948,377159,120892,989759,691323,790354,431422,936149,524124,414599,891625,738567,337901,760543,288907,1041843,624436,587042,558539,820320,626290,817638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003800s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001959s ]