SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 164101 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 164101 [ RunTime:0.003687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003053,995579,768390,74647,387401,138642,702872,994062,727796,913857,550970,76187,228613,305539,732816,507713,508583,21119,56309,699585,509322,594292,928288,814535,53134,842963,356138,795370,429348,773130,258413,1010507,243377,556374,1038709,447334,137889,31882,344819,25553,791049,169991,642406,218066,674167,189835,539217,335461,7242,410314,866532,734791,771305,865982,701250,557357,829079,994024,722247,1047912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 164101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 164101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]