SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001586s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802068 LIMIT 1 [ RunTime:0.001840s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802068 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563906,383780,529444,1043470,346546,209324,582924,338477,105380,946617,405409,341315,377217,520090,25574,609804,355702,922683,372756,178561,933081,700895,948992,565564,830124,598985,529971,24514,539828,40169,244089,780534,476187,500694,301175,753623,146754,303678,129648,190911,164824,164267,423120,507680,429145,920182,151471,235610,1007355,236343,420534,371078,130794,397377,214009,494939,443805,48904,581889,419040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003216s ]