SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017683 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017683 [ RunTime:0.002344s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690442,679300,887730,793812,29856,808171,35103,68891,708023,831378,225463,842086,181387,243184,303504,30129,124928,595265,622294,803221,829598,704292,105808,280554,308879,690663,740281,120445,928844,46459,533936,720554,483749,641927,183124,478493,931013,902755,789291,534515,512924,947327,470372,195858,953417,437366,1015326,995222,815429,517925,280971,314618,725567,19971,515125,829700,717687,654288,761909,846476) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001288s ]