SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549793 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549793 [ RunTime:0.003500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378992,334110,629236,505282,944254,854580,916983,473945,194242,1016309,984749,83703,851436,744170,342857,808932,310260,1025020,886972,102844,180445,605452,257922,342787,779336,309545,69061,586320,333807,359690,813234,353928,972890,124270,773226,869135,695703,503515,584615,160421,157173,848256,295431,173454,644564,951130,70279,530646,215395,942952,320042,167828,765863,302245,994951,727332,373908,580937,129995,677120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549793 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549793 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000963s ]