SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532307 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532307 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789404,284346,932448,779820,852836,890640,893484,278223,347244,122831,730713,764160,286340,184327,595932,745024,538090,626446,441699,1021034,250009,741202,881295,1008763,1027240,104581,179077,519603,548848,813879,1035346,701467,442061,952077,1017419,863665,660936,849254,724017,640326,294495,839069,710072,131214,207791,815424,75278,847667,326474,1040005,481305,728175,100600,562666,664651,303814,832427,1047390,162743,345880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]