SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312026 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312026 [ RunTime:0.002926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391012,285668,740825,126119,702323,848734,88910,998916,547137,314994,486272,684614,533024,476532,232895,168944,995967,51074,274571,418868,1026469,612456,372023,602631,170905,169879,1012824,173367,898202,483109,358194,284998,316172,511631,312735,930048,301451,597853,6492,399404,835970,765210,113151,389621,303585,87116,874424,749049,778402,935191,202289,198540,1040144,841974,999646,243904,215519,137942,354802,82738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002282s ]