SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534258 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534258 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441204,39224,1007251,89380,228373,1030513,826367,574515,613653,279181,962135,445333,468056,274629,1013975,741954,423205,580522,177089,223431,127419,218408,751196,353378,646089,191781,489604,249623,873679,236573,495271,716058,885705,876740,723415,690359,307244,530805,1017560,357117,228478,347180,899026,40030,356887,151429,810841,541436,945106,290237,1003332,248085,739459,916602,179755,252665,827984,932985,681119,50595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]